Computer Science for IGCSE & O level - Databases (Section 5 - No. 5)
Which of the following clauses are often used with the `JOIN` clause?
WHERE
ON
GROUP BY
ORDER BY
Explication
The `ON` clause is used to specify the join condition; `WHERE` filters rows after the join; `ORDER BY` sorts the results.